/****** Object:  StoredProcedure [dbo].[SFDA_attachment_clearCache]    Script Date: 07/27/2013 18:38:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create proc [dbo].[SFDA_attachment_clearCache]
@correspondingNo nvarchar(50)='',
@itemType nvarchar(50)='',
@workStation nvarchar(50)='',
@operator nvarchar(50)='',
@auditorType nvarchar(50)=''
as
set nocount on
delete from T_attachmentInfoUse where correspondingNo =@correspondingNo and itemType = @itemType and workStation = @workStation
and operator = @operator and auditorType = @auditorType
select 1 as messageInfo 
GO